Release 10.1A: OpenEdge Data Management:
Database Administration

Logging Summary

Displays status information for the database logging function. Figure 19–23 shows a sample Logging Summary Status display.

09/25/03        Status: Logging Summary 16:22 Crash protection:                Yes Delayed Commit:                  3 seconds Before-image I/O:                Reliable Before-image cluster age time:   60 seconds BI Writer status:                Executing Two-Phase Commit:                *** OFF *** After-image journalling: Yes After-image I/O: Reliable AI Writer status: Not executing

Figure 19–23: PROMON Logging Summary Status display

The display contains the following fields:

Crash protection — Yes, if crash protection is enabled; No, if it is not.
Delayed Commit — The current value of the Delayed BI File Write (-Mf) parameter.
Before-image I/O — One of the following:
Reliable if synchronous or direct I/O is being used for BI writes.
BUFFERED if buffered I/O is being used for BI writes. Buffered I/O is not recommended.
Before-image cluster age time — The period of time that must pass before a BI cluster is reused. This period ensures that database blocks flushed at checkpoint are moved from the UNIX buffers on disk. When this occurs, the transaction is recorded on disk.
BI Writer status — Executing, if a BIW is running.
Two-Phase Commit — ON, if two-phase commit is enabled; OFF, if it is not.
After-image journalling — ON, if after-imaging is enabled; OFF, if it is not.
After-image I/O — One of the following:
Reliable if synchronous or direct I/O is being used for AI writes.
BUFFERED if buffered I/O is being used for AI writes. Buffered I/O is not recommended.
AI Writer status — Executing, if an AIW is running.